﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.Common;
using SisVendas.Entidades;
using MySql.Data.MySqlClient;


namespace SisVendas.DataAccess
{

    public class StatusDAO
    {

        public static DataBaseHelper db = new DataBaseHelper();
        
        public static void Inserir(string nome, string descricao)
        {
            //StringBuilder comando = new StringBuilder("Insert into tbStatusVenda (nome, descricao) values (@nome, @descricao)");
            StringBuilder comando = new StringBuilder("InserirStatusVenda");
            List<MySqlParameter> parametros = new List<MySqlParameter>();

            parametros.Add(new MySqlParameter("pNome", nome));
            parametros.Add(new MySqlParameter("pDescricao", descricao));

            db.ExecuteNonQuery(comando.ToString(),CommandType.StoredProcedure,parametros.ToArray());
            
        }

       

    }
}
